﻿--================================================================================================
--                                 Change History
--                                 --------------
-- Date          Who     Description
-- -----------   ------  --------------------------------------------------
-- 01/Mar/2024   Chris   Added SkillsMaint Items
-- 20/Mar/2024   AndyB   Added SkillsStudents Items
-- 22/Apr/2024   AndyB   Added SKILLS-PERIODSUMMARY and SKILLS-QUESTIONBREAKDOWN
-- 30/Apr/2024   AndyB   Added 2 new fields to SKILLS-QUESTIONBREAKDOWN
-- 09/May/2024   AndyB   Added IMPORT-HISTORY
-- 10/Jun/2024   AndyB   Updated ColumnTitle for Overall_Period1-10
-- 12/Jun/2024   AndyB   Updated ColumnTitle for Student_Period1-10 and Course_Period1-10
--
--------------------------------------------------------------------------------------------------
--select distinct GridName from WebPlusTableColumn
--select * from WebPlusTableColumn
--------------------------------------------------------------------------------------------------

--Columns that had their names changed mid dev so ensure deleted and add again below
DELETE FROM WebPlusTableColumn WHERE GridName = 'SKILLSANSWERMAINTENANCE' AND ColumnName = 'SkillsAnswerType' and ColumnHeading = 'Answer Type'
DELETE FROM WebPlusTableColumn WHERE GridName = 'SkillsQuestionsMaintenance' AND ColumnName = 'SkillsAnswerType' and ColumnHeading = 'Answer Type'
DELETE FROM WebPlusTableColumn WHERE GridName = 'SkillsCourseQuestionsMaintenance' AND ColumnName = 'SkillsAnswerType' and ColumnHeading = 'Answer Type'
DELETE FROM WebPlusTableColumn WHERE GridName = 'SKILLSANSWERMAINTENANCE' AND ColumnName = 'SkillsAnswerDesc' and ColumnHeading = 'Answer Description'

DELETE FROM WebPlusTableColumn WHERE GridName = 'GROUPEDREPORTING' AND ColumnName = 'CountofEnrolsWithEnrolmentPoints'
DELETE FROM WebPlusTableColumn WHERE GridName = 'GROUPEDREPORTING' AND ColumnName = 'CountofEnrolsWithMissingEnrolPoints'
DELETE FROM WebPlusTableColumn WHERE GridName = 'GROUPEDREPORTING' AND ColumnName = 'CountofEnrolsWithIYPoints'
DELETE FROM WebPlusTableColumn WHERE GridName = 'GROUPEDREPORTING' AND ColumnName = 'CountofEnrolsWithMissingIYPoints'


--Skills Answers Grid
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSANSWERMAINTENANCE' AND ColumnName = 'SkillsAnswerType')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSANSWERMAINTENANCE', 'SkillsAnswerType', 'Response Category', '', 'SkillsAnswerType.Description')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSANSWERMAINTENANCE' AND ColumnName = 'SkillsAnswerDesc')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSANSWERMAINTENANCE', 'SkillsAnswerDesc', 'Description', '', 'SkillsAnswer.SkillsAnswerDesc')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSANSWERMAINTENANCE' AND ColumnName = 'Value')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSANSWERMAINTENANCE', 'Value', 'Value', '', 'SkillsAnswer.Value')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSANSWERMAINTENANCE' AND ColumnName = 'SkillsAnswerOrderBy')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSANSWERMAINTENANCE', 'SkillsAnswerOrderBy', 'Order By', '', 'SkillsAnswer.SkillsAnswerOrderBy')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSANSWERMAINTENANCE' AND ColumnName = 'SkillsAnswerIsObsolete')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSANSWERMAINTENANCE', 'SkillsAnswerIsObsolete', 'Is Obsolete', '', 'SkillsAnswer.SkillsAnswerIsObsolete')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSANSWERMAINTENANCE' AND ColumnName = 'InUse')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSANSWERMAINTENANCE', 'InUse', 'In Use', '', 'SkillsAnswer.InUse')
END

--Skills Periods Grid
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSPERIODMAINTENANCE' AND ColumnName = 'DefaultDescription')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSPERIODMAINTENANCE', 'DefaultDescription', 'Default Description', '', 'SkillsPeriod.DefaultDescription')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSPERIODMAINTENANCE' AND ColumnName = 'SkillsPeriodDescription')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSPERIODMAINTENANCE', 'SkillsPeriodDescription', 'Skills Period Description', '', 'SkillsPeriod.SkillsPeriodDescription')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSPERIODMAINTENANCE' AND ColumnName = 'ShowByDefaultOpenDate')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSPERIODMAINTENANCE', 'ShowByDefaultOpenDate', 'Visible From', '', 'SkillsPeriod.ShowByDefaultOpenDate')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSPERIODMAINTENANCE' AND ColumnName = 'ShowByDefaultCloseDate')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSPERIODMAINTENANCE', 'ShowByDefaultCloseDate', 'Visible To', '', 'SkillsPeriod.ShowByDefaultCloseDate')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSPERIODMAINTENANCE' AND ColumnName = 'IsEditable')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSPERIODMAINTENANCE', 'IsEditable', 'Are Answers Editable', '', 'SkillsPeriod.IsEditable')
END

--Skills Questions Grid
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SkillsQuestionsMaintenance' AND ColumnName = 'SkillsAnswerType')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SkillsQuestionsMaintenance', 'SkillsAnswerType', 'Response Category', '', 'SkillsAnswerType.SkillsAnswerTypeDesc')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SkillsQuestionsMaintenance' AND ColumnName = 'SkillsQuestionDesc')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SkillsQuestionsMaintenance', 'SkillsQuestionDesc', 'Question Description', '', 'SkillsQuestionDesc.Description')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SkillsQuestionsMaintenance' AND ColumnName = 'SkillsQuestionOrderBy')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SkillsQuestionsMaintenance', 'SkillsQuestionOrderBy', 'Order By', '', 'SkillsQuestion.SkillsQuestionOrderBy')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SkillsQuestionsMaintenance' AND ColumnName = 'SkillsQuestionIsObsolete')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SkillsQuestionsMaintenance', 'SkillsQuestionIsObsolete', 'Is Obsolete', '', 'SkillsQuestion.SkillsQuestionIsObsolete')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SkillsQuestionsMaintenance' AND ColumnName = 'SkillsQuestionInUse')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SkillsQuestionsMaintenance', 'SkillsQuestionInUse', 'In Use', '', 'Dynamic')
END



IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSANSWERTYPEMAINTENANCE' AND ColumnName = 'SkillsAnswerTypeDescription')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSANSWERTYPEMAINTENANCE', 'SkillsAnswerTypeDescription', 'Description', '', 'SkillsAnswerType.Description')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSANSWERTYPEMAINTENANCE' AND ColumnName = 'SkillsAnswerTypeOrderBy')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSANSWERTYPEMAINTENANCE', 'SkillsAnswerTypeOrderBy', 'Order By', '', 'SkillsAnswerType.OrderBy')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSANSWERTYPEMAINTENANCE' AND ColumnName = 'SkillsAnswerTypeIsObsolete')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSANSWERTYPEMAINTENANCE', 'SkillsAnswerTypeIsObsolete', 'Is Obsolete', '', 'SkillsAnswerType.IsObsolete')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSANSWERTYPEMAINTENANCE' AND ColumnName = 'SkillsAnswerTypeInUse')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSANSWERTYPEMAINTENANCE', 'SkillsAnswerTypeInUse', 'In Use', '', 'Dynamic')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SkillsCourseQuestionsMaintenance' AND ColumnName = 'SkillsAnswerType')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SkillsCourseQuestionsMaintenance', 'SkillsAnswerType', 'Response Category', '', 'SkillsAnswerType.SkillsAnswerTypeDesc')
END

-- Description
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SkillsCourseQuestionsMaintenance' AND ColumnName = 'Description')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SkillsCourseQuestionsMaintenance', 'Description', 'Question Text', '', 'Description')
END

-- OrderBy
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SkillsCourseQuestionsMaintenance' AND ColumnName = 'OrderBy')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SkillsCourseQuestionsMaintenance', 'OrderBy', 'Order By', '', 'OrderBy')
END

-- IsObsolete
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SkillsCourseQuestionsMaintenance' AND ColumnName = 'IsObsolete')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SkillsCourseQuestionsMaintenance', 'IsObsolete', 'Is Obsolete', '', 'IsObsolete')
END

-- InUse
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SkillsCourseQuestionsMaintenance' AND ColumnName = 'InUse')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SkillsCourseQuestionsMaintenance', 'InUse', 'In Use', '', 'Dynamic')
END






-----------------------------------
-- Skills Students Grid (VA or EM)
-----------------------------------

--select * from WebPlusTableColumn where GridName = 'SKILLSSTUDENTS'
--DELETE FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS'

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'CompletionIcon')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'CompletionIcon', ' ', '', '{EstactVAorEngMat_Enrolment_InYear}.CompletionDescription  [sp_WebPlus_{VAorEM}Skills_Select]')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'StudentRef')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'StudentRef', 'Student Ref', '', '{EstactVAorEngMat_Enrolment_InYear}.StudentRef  [sp_WebPlus_{VAorEM}Skills_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'Surname')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'Surname', 'Surname', '', '{EstactVAorEngMat_Enrolment_InYear}.Surname  [sp_WebPlus_{VAorEM}Skills_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'Forenames')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'Forenames', 'Forename', '', '{EstactVAorEngMat_Enrolment_InYear}.Forenames  [sp_WebPlus_{VAorEM}Skills_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'Age')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'Age', 'Age', '', '{EstactVAorEngMat_Enrolment_InYear}.Age  [sp_WebPlus_{VAorEM}Skills_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'DOB')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'DOB', 'DOB', '', '{EstactVAorEngMat_Enrolment_InYear}.DOB  [sp_WebPlus_{VAorEM}Skills_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'Ethnicity')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'Ethnicity', 'Ethnicity', '', '{EstactVAorEngMat_Enrolment_InYear}.Ethnicity  [sp_WebPlus_{VAorEM}Skills_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'Gender')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'Gender', 'Gender', '', '{EstactVAorEngMat_Enrolment_InYear}.Gender  [sp_WebPlus_{VAorEM}Skills_Select]')
END



IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'CourseCode')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'CourseCode', 'Course Code', '', '{EstactVAorEngMat_Enrolment_InYear}.CourseCode   [sp_WebPlus_{VAorEM}Skills_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'CourseTitle')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'CourseTitle', 'Course Title', '', '{EstactVAorEngMat_Enrolment_InYear}.CourseCode   [sp_WebPlus_{VAorEM}Skills_Select]')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'CountOfSkillsCourseQuestion')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'CountOfSkillsCourseQuestion', 'Course Questions', '', 'Calculated: SELECT Count(ID) FROM SkillsCourseQuestion  [sp_WebPlus_{VAorEM}Skills_Select]')
END


IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'Student_Period1')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'Student_Period1', 'Cross-College<br>Resp &nbsp; &nbsp; Avg', 'Number of responses and average score for cross-college questions only', 'vSkillsStudentOnlyAnswer_CountPivot.Period01 and vSkillsStudentOnlyAnswer_AvgPivot.Period01  [sp_WebPlus_{VAorEM}Skills_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'Course_Period1')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'Course_Period1', 'Course<br>Resp &nbsp; &nbsp; Avg', 'Number of responses and average score for questions relating to this course only', 'vSkillsCourseStudentOnlyAnswer_CountPivot.Period01 and vSkillsCourseStudentOnlyAnswer_AvgPivot.Period01  [sp_WebPlus_{VAorEM}Skills_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'Overall_Period1')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'Overall_Period1', 'Overall<br>Resp &nbsp; &nbsp; Avg', 'Includes Cross-College answers plus ALL Course answers', 'vSkillsOverallStudentAnswer_CountPivot.Period01 and vSkillsOverallStudentAnswer_AvgPivot.Period01  [sp_WebPlus_{VAorEM}Skills_Select]')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'Student_Period2')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'Student_Period2', 'Cross-College<br>Resp &nbsp; &nbsp; Avg', 'Number of responses and average score for cross-college questions only', 'vSkillsStudentOnlyAnswer_CountPivot.Period02 and vSkillsStudentOnlyAnswer_AvgPivot.Period02  [sp_WebPlus_{VAorEM}Skills_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'Course_Period2')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'Course_Period2', 'Course<br>Resp &nbsp; &nbsp; Avg', 'Number of responses and average score for questions relating to this course only', 'vSkillsCourseStudentOnlyAnswer_CountPivot.Period02 and vSkillsCourseStudentOnlyAnswer_AvgPivot.Period02  [sp_WebPlus_{VAorEM}Skills_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'Overall_Period2')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'Overall_Period2', 'Overall<br>Resp &nbsp; &nbsp; Avg', 'Includes Cross-College answers plus ALL Course answers', 'vSkillsOverallStudentAnswer_CountPivot.Period02 and vSkillsOverallStudentAnswer_AvgPivot.Period02  [sp_WebPlus_{VAorEM}Skills_Select]')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'Student_Period3')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'Student_Period3', 'Cross-College<br>Resp &nbsp; &nbsp; Avg', 'Number of responses and average score for cross-college questions only', 'vSkillsStudentOnlyAnswer_CountPivot.Period03 and vSkillsStudentOnlyAnswer_AvgPivot.Period03  [sp_WebPlus_{VAorEM}Skills_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'Course_Period3')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'Course_Period3', 'Course<br>Resp &nbsp; &nbsp; Avg', 'Number of responses and average score for questions relating to this course only', 'vSkillsCourseStudentOnlyAnswer_CountPivot.Period03 and vSkillsCourseStudentOnlyAnswer_AvgPivot.Period03  [sp_WebPlus_{VAorEM}Skills_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'Overall_Period3')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'Overall_Period3', 'Overall<br>Resp &nbsp; &nbsp; Avg', 'Includes Cross-College answers plus ALL Course answers', 'vSkillsOverallStudentAnswer_CountPivot.Period03 and vSkillsOverallStudentAnswer_AvgPivot.Period03  [sp_WebPlus_{VAorEM}Skills_Select]')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'Student_Period4')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'Student_Period4', 'Cross-College<br>Resp &nbsp; &nbsp; Avg', 'Number of responses and average score for cross-college questions only', 'vSkillsStudentOnlyAnswer_CountPivot.Period04 and vSkillsStudentOnlyAnswer_AvgPivot.Period04  [sp_WebPlus_{VAorEM}Skills_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'Course_Period4')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'Course_Period4', 'Course<br>Resp &nbsp; &nbsp; Avg', 'Number of responses and average score for questions relating to this course only', 'vSkillsCourseStudentOnlyAnswer_CountPivot.Period04 and vSkillsCourseStudentOnlyAnswer_AvgPivot.Period04  [sp_WebPlus_{VAorEM}Skills_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'Overall_Period4')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'Overall_Period4', 'Overall<br>Resp &nbsp; &nbsp; Avg', 'Includes Cross-College answers plus ALL Course answers', 'vSkillsOverallStudentAnswer_CountPivot.Period04 and vSkillsOverallStudentAnswer_AvgPivot.Period04  [sp_WebPlus_{VAorEM}Skills_Select]')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'Student_Period5')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'Student_Period5', 'Cross-College<br>Resp &nbsp; &nbsp; Avg', 'Number of responses and average score for cross-college questions only', 'vSkillsStudentOnlyAnswer_CountPivot.Period05 and vSkillsStudentOnlyAnswer_AvgPivot.Period05  [sp_WebPlus_{VAorEM}Skills_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'Course_Period5')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'Course_Period5', 'Course<br>Resp &nbsp; &nbsp; Avg', 'Number of responses and average score for questions relating to this course only', 'vSkillsCourseStudentOnlyAnswer_CountPivot.Period05 and vSkillsCourseStudentOnlyAnswer_AvgPivot.Period05  [sp_WebPlus_{VAorEM}Skills_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'Overall_Period5')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'Overall_Period5', 'Overall<br>Resp &nbsp; &nbsp; Avg', 'Includes Cross-College answers plus ALL Course answers', 'vSkillsOverallStudentAnswer_CountPivot.Period05 and vSkillsOverallStudentAnswer_AvgPivot.Period05  [sp_WebPlus_{VAorEM}Skills_Select]')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'Student_Period6')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'Student_Period6', 'Cross-College<br>Resp &nbsp; &nbsp; Avg', 'Number of responses and average score for cross-college questions only', 'vSkillsStudentOnlyAnswer_CountPivot.Period06 and vSkillsStudentOnlyAnswer_AvgPivot.Period06  [sp_WebPlus_{VAorEM}Skills_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'Course_Period6')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'Course_Period6', 'Course<br>Resp &nbsp; &nbsp; Avg', 'Number of responses and average score for questions relating to this course only', 'vSkillsCourseStudentOnlyAnswer_CountPivot.Period06 and vSkillsCourseStudentOnlyAnswer_AvgPivot.Period06  [sp_WebPlus_{VAorEM}Skills_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'Overall_Period6')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'Overall_Period6', 'Overall<br>Resp &nbsp; &nbsp; Avg', 'Includes Cross-College answers plus ALL Course answers', 'vSkillsOverallStudentAnswer_CountPivot.Period06 and vSkillsOverallStudentAnswer_AvgPivot.Period06  [sp_WebPlus_{VAorEM}Skills_Select]')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'Student_Period7')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'Student_Period7', 'Cross-College<br>Resp &nbsp; &nbsp; Avg', 'Number of responses and average score for cross-college questions only', 'vSkillsStudentOnlyAnswer_CountPivot.Period07 and vSkillsStudentOnlyAnswer_AvgPivot.Period07  [sp_WebPlus_{VAorEM}Skills_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'Course_Period7')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'Course_Period7', 'Course<br>Resp &nbsp; &nbsp; Avg', 'Number of responses and average score for questions relating to this course only', 'vSkillsCourseStudentOnlyAnswer_CountPivot.Period07 and vSkillsCourseStudentOnlyAnswer_AvgPivot.Period07  [sp_WebPlus_{VAorEM}Skills_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'Overall_Period7')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'Overall_Period7', 'Overall<br>Resp &nbsp; &nbsp; Avg', 'Includes Cross-College answers plus ALL Course answers', 'vSkillsOverallStudentAnswer_CountPivot.Period07 and vSkillsOverallStudentAnswer_AvgPivot.Period07  [sp_WebPlus_{VAorEM}Skills_Select]')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'Student_Period8')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'Student_Period8', 'Cross-College<br>Resp &nbsp; &nbsp; Avg', 'Number of responses and average score for cross-college questions only', 'vSkillsStudentOnlyAnswer_CountPivot.Period08 and vSkillsStudentOnlyAnswer_AvgPivot.Period08  [sp_WebPlus_{VAorEM}Skills_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'Course_Period8')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'Course_Period8', 'Course<br>Resp &nbsp; &nbsp; Avg', 'Number of responses and average score for questions relating to this course only', 'vSkillsCourseStudentOnlyAnswer_CountPivot.Period08 and vSkillsCourseStudentOnlyAnswer_AvgPivot.Period08  [sp_WebPlus_{VAorEM}Skills_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'Overall_Period8')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'Overall_Period8', 'Overall<br>Resp &nbsp; &nbsp; Avg', 'Includes Cross-College answers plus ALL Course answers', 'vSkillsOverallStudentAnswer_CountPivot.Period08 and vSkillsOverallStudentAnswer_AvgPivot.Period08  [sp_WebPlus_{VAorEM}Skills_Select]')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'Student_Period9')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'Student_Period9', 'Cross-College<br>Resp &nbsp; &nbsp; Avg', 'Number of responses and average score for cross-college questions only', 'vSkillsStudentOnlyAnswer_CountPivot.Period09 and vSkillsStudentOnlyAnswer_AvgPivot.Period09  [sp_WebPlus_{VAorEM}Skills_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'Course_Period9')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'Course_Period9', 'Course<br>Resp &nbsp; &nbsp; Avg', 'Number of responses and average score for questions relating to this course only', 'vSkillsCourseStudentOnlyAnswer_CountPivot.Period09 and vSkillsCourseStudentOnlyAnswer_AvgPivot.Period09  [sp_WebPlus_{VAorEM}Skills_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'Overall_Period9')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'Overall_Period9', 'Overall<br>Resp &nbsp; &nbsp; Avg', 'Includes Cross-College answers plus ALL Course answers', 'vSkillsOverallStudentAnswer_CountPivot.Period09 and vSkillsOverallStudentAnswer_AvgPivot.Period09  [sp_WebPlus_{VAorEM}Skills_Select]')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'Student_Period10')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'Student_Period10', 'Cross-College<br>Resp &nbsp; &nbsp; Avg', 'Number of responses and average score for cross-college questions only', 'vSkillsStudentOnlyAnswer_CountPivot.Period10 and vSkillsStudentOnlyAnswer_AvgPivot.Period10  [sp_WebPlus_{VAorEM}Skills_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'Course_Period10')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'Course_Period10', 'Course<br>Resp &nbsp; &nbsp; Avg', 'Number of responses and average score for questions relating to this course only', 'vSkillsCourseStudentOnlyAnswer_CountPivot.Period10 and vSkillsCourseStudentOnlyAnswer_AvgPivot.Period10  [sp_WebPlus_{VAorEM}Skills_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'Overall_Period10')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'Overall_Period10', 'Overall<br>Resp &nbsp; &nbsp; Avg', 'Includes Cross-College answers plus ALL Course answers', 'vSkillsOverallStudentAnswer_CountPivot.Period10 and vSkillsOverallStudentAnswer_AvgPivot.Period10  [sp_WebPlus_{VAorEM}Skills_Select]')
END


IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'CompletionDescription')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'CompletionDescription', 'Completion', '', '{EstactVAorEngMat_Enrolment_InYear}.CompletionDescription  [sp_WebPlus_{VAorEM}Skills_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'NVQLevel')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'NVQLevel', 'NVQ Level', '', '{EstactVAorEngMat_Enrolment_InYear}.NVQLevel  [sp_WebPlus_{VAorEM}Skills_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'StartDate')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'StartDate', 'Start Date', '', '{EstactVAorEngMat_Enrolment_InYear}.StartDate  [sp_WebPlus_{VAorEM}Skills_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'PlannedEndDate')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'PlannedEndDate', 'Planned EndDate', '', '{EstactVAorEngMat_Enrolment_InYear}.PlannedEndDate  [sp_WebPlus_{VAorEM}Skills_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'ActualEndDate')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'ActualEndDate', 'Actual EndDate', '', '{EstactVAorEngMat_Enrolment_InYear}.ActualEndDate  [sp_WebPlus_{VAorEM}Skills_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSSTUDENTS' AND ColumnName = 'EnrolmentGrade')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSSTUDENTS', 'EnrolmentGrade', 'Final Grade', '', '{EstactVAorEngMat_Enrolment_InYear}.EnrolmentGrade  [sp_WebPlus_{VAorEM}Skills_Select]')
END



-----------------------------------
-- Skills Cross-College Questions
-----------------------------------

--SELECT * from WebPlusTableColumn where GridName = 'SKILLSCROSSCOLLEGEQUESTIONS'
--DELETE FROM WebPlusTableColumn WHERE GridName = 'SKILLSCROSSCOLLEGEQUESTIONS'

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSCROSSCOLLEGEQUESTIONS' AND ColumnName = 'Question')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSCROSSCOLLEGEQUESTIONS', 'Question', 'Question', '', 'SkillsStudentAnswer -> SkillsQuestion.Description  [sp_WebPlus_SkillsStudentQuestions_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSCROSSCOLLEGEQUESTIONS' AND ColumnName = 'Answer')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSCROSSCOLLEGEQUESTIONS', 'Answer', 'Answer', '', 'SkillsStudentAnswer -> SkillsAnswer.Description  [sp_WebPlus_SkillsStudentQuestions_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSCROSSCOLLEGEQUESTIONS' AND ColumnName = 'AnswerComment')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSCROSSCOLLEGEQUESTIONS', 'AnswerComment', 'Comments', '', 'SkillsStudentAnswer.AnswerText  [sp_WebPlus_SkillsStudentQuestions_Select]')
END


----------------------------
-- Skills Course Questions
----------------------------

--SELECT * from WebPlusTableColumn where GridName = 'SKILLSCOURSEQUESTIONS'
--DELETE FROM WebPlusTableColumn WHERE GridName = 'SKILLSCOURSEQUESTIONS'

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSCOURSEQUESTIONS' AND ColumnName = 'Question')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSCOURSEQUESTIONS', 'Question', 'Question', '', 'SkillsCourseStudentAnswer -> SkillsQuestion.Description  [sp_WebPlus_SkillsStudentCourseQuestions_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSCOURSEQUESTIONS' AND ColumnName = 'Answer')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSCOURSEQUESTIONS', 'Answer', 'Answer', '', 'SkillsCourseStudentAnswer -> SkillsAnswer.Description  [sp_WebPlus_SkillsStudentCourseQuestions_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLSCOURSEQUESTIONS' AND ColumnName = 'AnswerComment')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLSCOURSEQUESTIONS', 'AnswerComment', 'Comments', '', 'SkillsCourseStudentAnswer.AnswerText  [sp_WebPlus_SkillsStudentCourseQuestions_Select]')
END




----------------------------
-- Skills Period Summary
----------------------------

--SELECT count(*) from WebPlusTableColumn where GridName = 'SKILLS-PERIODSUMMARY'
--DELETE FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY'

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'AcademicYearID')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'AcademicYearID', 'AcademicYear', '', 'Based on the Academic Year Selected  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'CompletionDescription')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'CompletionDescription', 'Completion Status', '', 'Calculated from OGP_Enrolment.OverallCompletionID  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'StudentRef')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'StudentRef', 'Student Ref', '', 'OGP_Student.StudentRef  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'Surname')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'Surname', 'Surname', '', 'OGP_Student.Surname  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'Forenames')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'Forenames', 'Forename', '', 'OGP_Student.Forenames  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'DOB')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'DOB', 'DoB', '', 'OGP_Student.DOB  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'Age')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'Age', 'AgeOn31Aug', '', 'Calculated: GetAgeOnDate(OGP_Student.DOB)  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'Gender')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'Gender', 'Gender', '', 'OGP_Student.Gender  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'Ethnicity')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'Ethnicity', 'Ethnicity', '', 'OGP_Student.EthnicityID -> Ethnicity.Code  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'FreeSchoolMeal')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'FreeSchoolMeal', 'Free School Meal', '', 'OGP_Student.FreeSchoolMeal  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'LLDDandHealthProblem')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'LLDDandHealthProblem', 'LLDDandHealthProblem', '', 'OGP_Student.LLDDandHealthProblemID -> LLDDandHealthProblem.Code - LLDDandHealthProblem.[Definition]  [sp_WebPlus_Skills_Reporting_ByStudent]')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'UserDefinedField')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'UserDefinedField', '[COL_HDG]', '[COL_TITLE]', 'OGP_Student.[FIELD_NAME]  [sp_WebPlus_Skills_Reporting_ByStudent]')
END


--IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'NVQLevel')
--BEGIN
--    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
--    VALUES ('SKILLS-PERIODSUMMARY', 'NVQLevel', 'NVQ Level', '', 'NVQLevel  [sp_WebPlus_Skills_Reporting_ByStudent]')
--END
--IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'EnrolmentGrade')
--BEGIN
--    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
--    VALUES ('SKILLS-PERIODSUMMARY', 'EnrolmentGrade', 'Grade', '', 'Grade  [sp_WebPlus_Skills_Reporting_ByStudent]')
--END
--IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'StartDate')
--BEGIN
--    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
--    VALUES ('SKILLS-PERIODSUMMARY', 'StartDate', 'Start Date', '', 'StartDate  [sp_WebPlus_Skills_Reporting_ByStudent]')
--END
--IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'PlannedEndDate')
--BEGIN
--    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
--    VALUES ('SKILLS-PERIODSUMMARY', 'PlannedEndDate', 'Planned End Date', '', 'PlannedEndDate  [sp_WebPlus_Skills_Reporting_ByStudent]')
--END
--IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'ActualEndDate')
--BEGIN
--    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
--    VALUES ('SKILLS-PERIODSUMMARY', 'ActualEndDate', 'Actual End Date', '', 'ActualEndDate  [sp_WebPlus_Skills_Reporting_ByStudent]')
--END
--IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'GroupCode')
--BEGIN
--    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
--    VALUES ('SKILLS-PERIODSUMMARY', 'GroupCode', 'Group Code', '', 'GroupCode  [sp_WebPlus_Skills_Reporting_ByStudent]')
--END
--IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'GroupTitle')
--BEGIN
--    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
--    VALUES ('SKILLS-PERIODSUMMARY', 'GroupTitle', 'Group Title', '', 'GroupTitle  [sp_WebPlus_Skills_Reporting_ByStudent]')
--END
--IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'CourseCode')
--BEGIN
--    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
--    VALUES ('SKILLS-PERIODSUMMARY', 'CourseCode', 'Course Code', '', 'CourseCode  [sp_WebPlus_Skills_Reporting_ByStudent]')
--END
--IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'CourseTitle')
--BEGIN
--    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
--    VALUES ('SKILLS-PERIODSUMMARY', 'CourseTitle', 'Course Title', '', 'CourseTitle  [sp_WebPlus_Skills_Reporting_ByStudent]')
--END
--IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'LearningAimRef')
--BEGIN
--    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
--    VALUES ('SKILLS-PERIODSUMMARY', 'LearningAimRef', 'Learning Aim Ref', '', 'LearningAimRef  [sp_WebPlus_Skills_Reporting_ByStudent]')
--END
--IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'LearningAimTitle')
--BEGIN
--    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
--    VALUES ('SKILLS-PERIODSUMMARY', 'LearningAimTitle', 'Learning Aim Title', '', 'LearningAimTitle  [sp_WebPlus_Skills_Reporting_ByStudent]')
--END


--Cross-College
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'CrossCollegeAvg_Period1')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'CrossCollegeAvg_Period1', 'Cross-College: Period01 Avg', '', 'Calculated  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'CrossCollegeAvg_Period2')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'CrossCollegeAvg_Period2', 'Cross-College: Period02 Avg', '', 'Calculated  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'CrossCollegeAvg_Period3')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'CrossCollegeAvg_Period3', 'Cross-College: Period03 Avg', '', 'Calculated  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'CrossCollegeAvg_Period4')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'CrossCollegeAvg_Period4', 'Cross-College: Period04 Avg', '', 'Calculated  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'CrossCollegeAvg_Period5')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'CrossCollegeAvg_Period5', 'Cross-College: Period05 Avg', '', 'Calculated  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'CrossCollegeAvg_Period6')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'CrossCollegeAvg_Period6', 'Cross-College: Period06 Avg', '', 'Calculated  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'CrossCollegeAvg_Period7')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'CrossCollegeAvg_Period7', 'Cross-College: Period07 Avg', '', 'Calculated  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'CrossCollegeAvg_Period8')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'CrossCollegeAvg_Period8', 'Cross-College: Period08 Avg', '', 'Calculated  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'CrossCollegeAvg_Period9')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'CrossCollegeAvg_Period9', 'Cross-College: Period09 Avg', '', 'Calculated  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'CrossCollegeAvg_Period10')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'CrossCollegeAvg_Period10', 'Cross-College: Period10 Avg', '', 'Calculated  [sp_WebPlus_Skills_Reporting_ByStudent]')
END


IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'CrossCollegeAvg_Difference')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'CrossCollegeAvg_Difference', 'Cross-College: Difference', '', 'Calculated  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'CrossCollegeAvg_StartingPeriod')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'CrossCollegeAvg_StartingPeriod', 'Cross-College: Starting Period', '', 'Calculated  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'CrossCollegeAvg_MostRecentPeriod')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'CrossCollegeAvg_MostRecentPeriod', 'Cross-College: MostRecent Period', '', 'Calculated  [sp_WebPlus_Skills_Reporting_ByStudent]')
END


--AllCourses
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'AllCoursesAvg_Period1')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'AllCoursesAvg_Period1', 'All Courses: Period01 Avg', '', 'Calculated  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'AllCoursesAvg_Period2')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'AllCoursesAvg_Period2', 'All Courses: Period02 Avg', '', 'Calculated  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'AllCoursesAvg_Period3')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'AllCoursesAvg_Period3', 'All Courses: Period03 Avg', '', 'Calculated  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'AllCoursesAvg_Period4')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'AllCoursesAvg_Period4', 'All Courses: Period04 Avg', '', 'Calculated  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'AllCoursesAvg_Period5')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'AllCoursesAvg_Period5', 'All Courses: Period05 Avg', '', 'Calculated  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'AllCoursesAvg_Period6')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'AllCoursesAvg_Period6', 'All Courses: Period06 Avg', '', 'Calculated  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'AllCoursesAvg_Period7')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'AllCoursesAvg_Period7', 'All Courses: Period07 Avg', '', 'Calculated  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'AllCoursesAvg_Period8')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'AllCoursesAvg_Period8', 'All Courses: Period08 Avg', '', 'Calculated  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'AllCoursesAvg_Period9')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'AllCoursesAvg_Period9', 'All Courses: Period09 Avg', '', 'Calculated  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'AllCoursesAvg_Period10')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'AllCoursesAvg_Period10', 'All Courses: Period10 Avg', '', 'Calculated  [sp_WebPlus_Skills_Reporting_ByStudent]')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'AllCoursesAvg_Difference')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'AllCoursesAvg_Difference', 'All Courses: Difference', '', 'Calculated  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'AllCoursesAvg_StartingPeriod')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'AllCoursesAvg_StartingPeriod', 'All Courses: Starting Period', '', 'Calculated  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'AllCoursesAvg_MostRecentPeriod')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'AllCoursesAvg_MostRecentPeriod', 'All Courses: MostRecent Period', '', 'Calculated  [sp_WebPlus_Skills_Reporting_ByStudent]')
END


--Overall
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'OverallAvg_Period1')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'OverallAvg_Period1', 'Overall: Period01 Avg', '', 'Calculated  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'OverallAvg_Period2')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'OverallAvg_Period2', 'Overall: Period02 Avg', '', 'Calculated  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'OverallAvg_Period3')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'OverallAvg_Period3', 'Overall: Period03 Avg', '', 'Calculated  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'OverallAvg_Period4')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'OverallAvg_Period4', 'Overall: Period04 Avg', '', 'Calculated  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'OverallAvg_Period5')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'OverallAvg_Period5', 'Overall: Period05 Avg', '', 'Calculated  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'OverallAvg_Period6')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'OverallAvg_Period6', 'Overall: Period06 Avg', '', 'Calculated  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'OverallAvg_Period7')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'OverallAvg_Period7', 'Overall: Period07 Avg', '', 'Calculated  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'OverallAvg_Period8')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'OverallAvg_Period8', 'Overall: Period08 Avg', '', 'Calculated  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'OverallAvg_Period9')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'OverallAvg_Period9', 'Overall: Period09 Avg', '', 'Calculated  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'OverallAvg_Period10')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'OverallAvg_Period10', 'Overall: Period10 Avg', '', 'Calculated  [sp_WebPlus_Skills_Reporting_ByStudent]')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'OverallAvg_Difference')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'OverallAvg_Difference', 'Overall: Difference', '', 'Calculated  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'OverallAvg_StartingPeriod')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'OverallAvg_StartingPeriod', 'Overall: Starting Period', '', 'Calculated  [sp_WebPlus_Skills_Reporting_ByStudent]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-PERIODSUMMARY' AND ColumnName = 'OverallAvg_MostRecentPeriod')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-PERIODSUMMARY', 'OverallAvg_MostRecentPeriod', 'Overall: MostRecent Period', '', 'Calculated  [sp_WebPlus_Skills_Reporting_ByStudent]')
END



-----------------------------
-- Skills Question Breakdown
-----------------------------

--SELECT count(*) from WebPlusTableColumn where GridName = 'SKILLS-QUESTIONBREAKDOWN'
--DELETE FROM WebPlusTableColumn WHERE GridName = 'SKILLS-QUESTIONBREAKDOWN'

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-QUESTIONBREAKDOWN' AND ColumnName = 'AcademicYearID')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-QUESTIONBREAKDOWN', 'AcademicYearID', 'AcademicYear', '', 'Based on the Academic Year Selected  [sp_WebPlus_Skills_Reporting_CrossCollege_ByStudent_ByQuestion]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-QUESTIONBREAKDOWN' AND ColumnName = 'CompletionDescription')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-QUESTIONBREAKDOWN', 'CompletionDescription', 'Completion Status', '', 'Calculated from OGP_Enrolment.OverallCompletionID  [sp_WebPlus_Skills_Reporting_CrossCollege_ByStudent_ByQuestion]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-QUESTIONBREAKDOWN' AND ColumnName = 'StudentRef')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-QUESTIONBREAKDOWN', 'StudentRef', 'Student Ref', '', 'OGP_Student.StudentRef  [sp_WebPlus_Skills_Reporting_CrossCollege_ByStudent_ByQuestion]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-QUESTIONBREAKDOWN' AND ColumnName = 'Surname')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-QUESTIONBREAKDOWN', 'Surname', 'Surname', '', 'OGP_Student.Surname  [sp_WebPlus_Skills_Reporting_CrossCollege_ByStudent_ByQuestion]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-QUESTIONBREAKDOWN' AND ColumnName = 'Forenames')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-QUESTIONBREAKDOWN', 'Forenames', 'Forename', '', 'OGP_Student.Forenames  [sp_WebPlus_Skills_Reporting_CrossCollege_ByStudent_ByQuestion]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-QUESTIONBREAKDOWN' AND ColumnName = 'DOB')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-QUESTIONBREAKDOWN', 'DOB', 'DoB', '', 'OGP_Student.DOB  [sp_WebPlus_Skills_Reporting_CrossCollege_ByStudent_ByQuestion]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-QUESTIONBREAKDOWN' AND ColumnName = 'Age')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-QUESTIONBREAKDOWN', 'Age', 'AgeOn31Aug', '', 'Calculated: GetAgeOnDate(OGP_Student.DOB)  [sp_WebPlus_Skills_Reporting_CrossCollege_ByStudent_ByQuestion]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-QUESTIONBREAKDOWN' AND ColumnName = 'Gender')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-QUESTIONBREAKDOWN', 'Gender', 'Gender', '', 'OGP_Student.Gender  [sp_WebPlus_Skills_Reporting_CrossCollege_ByStudent_ByQuestion]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-QUESTIONBREAKDOWN' AND ColumnName = 'Ethnicity')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-QUESTIONBREAKDOWN', 'Ethnicity', 'Ethnicity', '', 'OGP_Student.EthnicityID -> Ethnicity.Code  [sp_WebPlus_Skills_Reporting_CrossCollege_ByStudent_ByQuestion]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-QUESTIONBREAKDOWN' AND ColumnName = 'FreeSchoolMeal')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-QUESTIONBREAKDOWN', 'FreeSchoolMeal', 'Free School Meal', '', 'OGP_Student.FreeSchoolMeal  [sp_WebPlus_Skills_Reporting_CrossCollege_ByStudent_ByQuestion]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-QUESTIONBREAKDOWN' AND ColumnName = 'LLDDandHealthProblem')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-QUESTIONBREAKDOWN', 'LLDDandHealthProblem', 'LLDDandHealthProblem', '', 'OGP_Student.LLDDandHealthProblemID -> LLDDandHealthProblem.Code - LLDDandHealthProblem.[Definition]  [sp_WebPlus_Skills_Reporting_CrossCollege_ByStudent_ByQuestion]')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-QUESTIONBREAKDOWN' AND ColumnName = 'UserDefinedField')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-QUESTIONBREAKDOWN', 'UserDefinedField', '[COL_HDG]', '[COL_TITLE]', 'OGP_Student.[FIELD_NAME]  [sp_WebPlus_Skills_Reporting_CrossCollege_ByStudent_ByQuestion]')
END


--Cross-College
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-QUESTIONBREAKDOWN' AND ColumnName = 'CrossCollegeAvg_Period1')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-QUESTIONBREAKDOWN', 'CrossCollegeAvg_Period1', 'Cross-College: Period01 Avg', '', 'Calculated  [sp_WebPlus_Skills_Reporting_CrossCollege_ByStudent_ByQuestion]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-QUESTIONBREAKDOWN' AND ColumnName = 'CrossCollegeAvg_Period2')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-QUESTIONBREAKDOWN', 'CrossCollegeAvg_Period2', 'Cross-College: Period02 Avg', '', 'Calculated  [sp_WebPlus_Skills_Reporting_CrossCollege_ByStudent_ByQuestion]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-QUESTIONBREAKDOWN' AND ColumnName = 'CrossCollegeAvg_Period3')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-QUESTIONBREAKDOWN', 'CrossCollegeAvg_Period3', 'Cross-College: Period03 Avg', '', 'Calculated  [sp_WebPlus_Skills_Reporting_CrossCollege_ByStudent_ByQuestion]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-QUESTIONBREAKDOWN' AND ColumnName = 'CrossCollegeAvg_Period4')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-QUESTIONBREAKDOWN', 'CrossCollegeAvg_Period4', 'Cross-College: Period04 Avg', '', 'Calculated  [sp_WebPlus_Skills_Reporting_CrossCollege_ByStudent_ByQuestion]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-QUESTIONBREAKDOWN' AND ColumnName = 'CrossCollegeAvg_Period5')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-QUESTIONBREAKDOWN', 'CrossCollegeAvg_Period5', 'Cross-College: Period05 Avg', '', 'Calculated  [sp_WebPlus_Skills_Reporting_CrossCollege_ByStudent_ByQuestion]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-QUESTIONBREAKDOWN' AND ColumnName = 'CrossCollegeAvg_Period6')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-QUESTIONBREAKDOWN', 'CrossCollegeAvg_Period6', 'Cross-College: Period06 Avg', '', 'Calculated  [sp_WebPlus_Skills_Reporting_CrossCollege_ByStudent_ByQuestion]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-QUESTIONBREAKDOWN' AND ColumnName = 'CrossCollegeAvg_Period7')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-QUESTIONBREAKDOWN', 'CrossCollegeAvg_Period7', 'Cross-College: Period07 Avg', '', 'Calculated  [sp_WebPlus_Skills_Reporting_CrossCollege_ByStudent_ByQuestion]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-QUESTIONBREAKDOWN' AND ColumnName = 'CrossCollegeAvg_Period8')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-QUESTIONBREAKDOWN', 'CrossCollegeAvg_Period8', 'Cross-College: Period08 Avg', '', 'Calculated  [sp_WebPlus_Skills_Reporting_CrossCollege_ByStudent_ByQuestion]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-QUESTIONBREAKDOWN' AND ColumnName = 'CrossCollegeAvg_Period9')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-QUESTIONBREAKDOWN', 'CrossCollegeAvg_Period9', 'Cross-College: Period09 Avg', '', 'Calculated  [sp_WebPlus_Skills_Reporting_CrossCollege_ByStudent_ByQuestion]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-QUESTIONBREAKDOWN' AND ColumnName = 'CrossCollegeAvg_Period10')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-QUESTIONBREAKDOWN', 'CrossCollegeAvg_Period10', 'Cross-College: Period10 Avg', '', 'Calculated  [sp_WebPlus_Skills_Reporting_CrossCollege_ByStudent_ByQuestion]')
END


IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-QUESTIONBREAKDOWN' AND ColumnName = 'CrossCollegeAvg_Difference')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-QUESTIONBREAKDOWN', 'CrossCollegeAvg_Difference', 'Cross-College: Difference', '', 'Calculated  [sp_WebPlus_Skills_Reporting_CrossCollege_ByStudent_ByQuestion]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-QUESTIONBREAKDOWN' AND ColumnName = 'CrossCollegeAvg_StartingPeriod')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-QUESTIONBREAKDOWN', 'CrossCollegeAvg_StartingPeriod', 'Cross-College: Starting Period', '', 'Calculated  [sp_WebPlus_Skills_Reporting_CrossCollege_ByStudent_ByQuestion]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-QUESTIONBREAKDOWN' AND ColumnName = 'CrossCollegeAvg_MostRecentPeriod')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-QUESTIONBREAKDOWN', 'CrossCollegeAvg_MostRecentPeriod', 'Cross-College: MostRecent Period', '', 'Calculated  [sp_WebPlus_Skills_Reporting_CrossCollege_ByStudent_ByQuestion]')
END

--Added 30/Apr/2024
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-QUESTIONBREAKDOWN' AND ColumnName = 'CrossCollegeAvg_StartingPeriodValue')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-QUESTIONBREAKDOWN', 'CrossCollegeAvg_StartingPeriodValue', 'Cross-College: Starting Period Value', '', 'Calculated  [sp_WebPlus_Skills_Reporting_CrossCollege_ByStudent_ByQuestion]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'SKILLS-QUESTIONBREAKDOWN' AND ColumnName = 'CrossCollegeAvg_MostRecentPeriodValue')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('SKILLS-QUESTIONBREAKDOWN', 'CrossCollegeAvg_MostRecentPeriodValue', 'Cross-College: MostRecent Period Value', '', 'Calculated  [sp_WebPlus_Skills_Reporting_CrossCollege_ByStudent_ByQuestion]')
END


--GROUPEDREPORTING Updates (2/May/2024)
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'GROUPEDREPORTING' AND ColumnName = 'CountofEnrolsWithEnrolmentPoints')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('GROUPEDREPORTING', 'CountofEnrolsWithEnrolmentPoints', 'No. Enrols with Enrol Grades', '', 'Calculated  [sp_EstActVA_Grouping_Web]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'GROUPEDREPORTING' AND ColumnName = 'CountofEnrolsWithMissingEnrolPoints')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('GROUPEDREPORTING', 'CountofEnrolsWithMissingEnrolPoints', 'No. Enrols with Missing Enrol Grades', '', 'Calculated  [sp_EstActVA_Grouping_Web]')
END
--
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'GROUPEDREPORTING' AND ColumnName = 'CountofEnrolsWithIYPoints')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('GROUPEDREPORTING', 'CountofEnrolsWithIYPoints', 'No. Enrols with Recent IY Grades', '', 'Calculated  [sp_EstActVA_Grouping_Web]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'GROUPEDREPORTING' AND ColumnName = 'CountofEnrolsWithMissingIYPoints')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('GROUPEDREPORTING', 'CountofEnrolsWithMissingIYPoints', 'No. Enrols with Missing Recent IY Grades', '', 'Calculated  [sp_EstActVA_Grouping_Web]')
END




-----------------------------
-- IMPORT-HISTORY
-----------------------------

--SELECT count(*) from WebPlusTableColumn where GridName = 'IMPORT-HISTORY'
--DELETE FROM WebPlusTableColumn WHERE GridName = 'IMPORT-HISTORY'

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'IMPORT-HISTORY' AND ColumnName = 'ImportName')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('IMPORT-HISTORY', 'ImportName', 'Import Name', '', 'ImportName  [vImport_LatestInformation]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'IMPORT-HISTORY' AND ColumnName = 'ImportBy')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('IMPORT-HISTORY', 'ImportBy', 'Imported By', '', 'ImportBy  [vImport_LatestInformation]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'IMPORT-HISTORY' AND ColumnName = 'ImportSource')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('IMPORT-HISTORY', 'ImportSource', 'Source', '', 'ImportSource  [vImport_LatestInformation]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'IMPORT-HISTORY' AND ColumnName = 'LastImportedAcYrIDs')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('IMPORT-HISTORY', 'LastImportedAcYrIDs', 'Last AcYr', '', 'LastImportedAcYrIDs  [vImport_LatestInformation]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'IMPORT-HISTORY' AND ColumnName = 'ImportType')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('IMPORT-HISTORY', 'ImportType', 'Import Type', '', 'ImportType  [vImport_LatestInformation]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'IMPORT-HISTORY' AND ColumnName = 'ImportDate')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('IMPORT-HISTORY', 'ImportDate', 'Import Date', '', 'ImportDate  [vImport_LatestInformation]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'IMPORT-HISTORY' AND ColumnName = 'OrderBy')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('IMPORT-HISTORY', 'OrderBy', 'Order', '', 'OrderBy  [vImport_LatestInformation]')
END


